EXECUTIVE SUMMARY
PROBLEM ENCOUNTERED
1. While working on the dashboard, the Year over Year change
(YoY%) for some of the months shows zero value because there were missing data.
So, to come up with reasonable result there was a need to transfer some data
without affecting sales per month and total revenue. This work took much time
than desired.
2. Selecting the right KPI was the other problem occurred. MoM%
was initially attempted but it does not show the desired out put so there was a
need to change it to YoY%.
Easy
Guide to Bulk Replace Values in Power BI or Power Query